SELECT White,ifnull(WhiteElo,'<NULL>') AS WE,ifnull(WhiteTitle,'<NULL>') AS WT FROM Games GROUP BY White,WE,WT;
Bardzinski, Slawomir|<NULL>|<NULL>
Czarnomska, Joanna|<NULL>|<NULL>
Grabarczyk, Miroslaw|2438|<NULL>
Jedryczka, Krystian|2232|<NULL>
Kaminski, Mariusz|<NULL>|<NULL>
Klein, Zbigniew|<NULL>|<NULL>
Kwiatkowski, Pawel|<NULL>|<NULL>
Magierski, Dariusz|1611|<NULL>
Mroczek, Jaroslaw|<NULL>|<NULL>
Mroczek, Przemyslaw|1534|<NULL>
Oszczanowski, Witold|2068|<NULL>
Paprocki, Jaroslaw|2154|<NULL>
Potkanski, Michal|1556|<NULL>
Radwanski, Sebastian|1345|<NULL>
Sacharewicz, Krzysztof|1608|<NULL>
Szopa, Andrzej|1133|<NULL>
Szymanski, Jan|1775|<NULL>
Wisniewski, Przemyslaw|1992|<NULL>
----
SELECT Black,ifnull(BlackElo,'<NULL>') AS BE,ifnull(BlackTitle,'<NULL>') AS BT FROM Games GROUP BY Black,BE,BT;
Bardzinski, Slawomir|<NULL>|<NULL>
Czarnomska, Joanna|<NULL>|<NULL>
Grabarczyk, Miroslaw|2438|<NULL>
Jedryczka, Krystian|2232|<NULL>
Kaminski, Mariusz|<NULL>|<NULL>
Klein, Zbigniew|<NULL>|<NULL>
Kwiatkowski, Pawel|<NULL>|<NULL>
Magierski, Dariusz|1611|<NULL>
Mroczek, Jaroslaw|<NULL>|<NULL>
Mroczek, Przemyslaw|1534|<NULL>
Oszczanowski, Witold|2068|<NULL>
Paprocki, Jaroslaw|2154|<NULL>
Potkanski, Michal|1556|<NULL>
Radwanski, Sebastian|1345|<NULL>
Sacharewicz, Krzysztof|1608|<NULL>
Szopa, Andrzej|1133|<NULL>
Szymanski, Jan|1775|<NULL>
Wisniewski, Przemyslaw|1992|<NULL>
----
